package com.can.Mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.can.domain.po.Game;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface GameStoreMapper extends BaseMapper<Game> {
    @Select("""
        SELECT 
            id, 
            gamename,
            content, 
            DATE_FORMAT(created_at, '%Y年%c月%e日%H时%i分')  as createdAt
        FROM gamestore
        WHERE id = #{Id}
        """)
    Game GetGamedetailBYId(int Id);
}
